Reporte de Calidad para station

Dataset statistics

Number of variables	16
Number of observations	2270250
Missing cells	10144783
Missing cells (%)	27.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	649.1 MiB
Average record size in memory	299.8 B

Variable types

Text	1
DateTime	1
Numeric	13
Categorical	1

Alerts

`AQI` is highly overall correlated with `PM10` and 1 other fields	High correlation
`Benzene` is highly overall correlated with `Toluene` and 1 other fields	High correlation
`NO` is highly overall correlated with `NOx`	High correlation
`NO2` is highly overall correlated with `NOx`	High correlation
`NOx` is highly overall correlated with `NO` and 1 other fields	High correlation
`PM10` is highly overall correlated with `AQI` and 1 other fields	High correlation
`PM2.5` is highly overall correlated with `AQI` and 1 other fields	High correlation
`Toluene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`PM2.5` has 586093 (25.8%) missing values	Missing
`PM10` has 877210 (38.6%) missing values	Missing
`NO` has 498538 (22.0%) missing values	Missing
`NO2` has 475550 (20.9%) missing values	Missing
`NOx` has 429916 (18.9%) missing values	Missing
`NH3` has 1041931 (45.9%) missing values	Missing
`CO` has 445276 (19.6%) missing values	Missing
`SO2` has 684419 (30.1%) missing values	Missing
`O3` has 624138 (27.5%) missing values	Missing
`Benzene` has 751495 (33.1%) missing values	Missing
`Toluene` has 929412 (40.9%) missing values	Missing
`Xylene` has 1781769 (78.5%) missing values	Missing
`AQI` has 509518 (22.4%) missing values	Missing
`AQI_Bucket` has 509518 (22.4%) missing values	Missing
`CO` is highly skewed (γ1 = 32.05639945)	Skewed
`Benzene` is highly skewed (γ1 = 29.2881114)	Skewed
`NOx` has 116602 (5.1%) zeros	Zeros
`CO` has 153506 (6.8%) zeros	Zeros
`Benzene` has 333688 (14.7%) zeros	Zeros
`Toluene` has 262296 (11.6%) zeros	Zeros
`Xylene` has 207980 (9.2%) zeros	Zeros

Reproduction

Analysis started	2024-12-29 05:26:48.190197
Analysis finished	2024-12-29 05:29:31.012239
Duration	2 minutes and 42.82 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

StationId
Text

Distinct	96
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	134.2 MiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	11351250
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AP001
2nd row	AP001
3rd row	AP001
4th row	AP001
5th row	AP001

Value	Count	Frequency (%)
gj001	48192	2.1%
dl007	48192	2.1%
tn001	48192	2.1%
dl033	48192	2.1%
dl021	48192	2.1%
ka003	48192	2.1%
ka009	48192	2.1%
dl013	48192	2.1%
mh005	48192	2.1%
dl008	48192	2.1%
Other values (86)	1788330	78.8%

Most occurring characters

Value	Count	Frequency (%)
0	3655390	32.2%
L	1132467	10.0%
D	1132017	10.0%
1	949664	8.4%
3	490259	4.3%
2	468339	4.1%
A	357403	3.1%
K	325241	2.9%
5	286273	2.5%
T	275802	2.4%
Other values (17)	2278395	20.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11351250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	3655390	32.2%
L	1132467	10.0%
D	1132017	10.0%
1	949664	8.4%
3	490259	4.3%
2	468339	4.1%
A	357403	3.1%
K	325241	2.9%
5	286273	2.5%
T	275802	2.4%
Other values (17)	2278395	20.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11351250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	3655390	32.2%
L	1132467	10.0%
D	1132017	10.0%
1	949664	8.4%
3	490259	4.3%
2	468339	4.1%
A	357403	3.1%
K	325241	2.9%
5	286273	2.5%
T	275802	2.4%
Other values (17)	2278395	20.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11351250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	3655390	32.2%
L	1132467	10.0%
D	1132017	10.0%
1	949664	8.4%
3	490259	4.3%
2	468339	4.1%
A	357403	3.1%
K	325241	2.9%
5	286273	2.5%
T	275802	2.4%
Other values (17)	2278395	20.1%

Datetime
Date

Distinct	48192
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	17.3 MiB

Minimum	2015-01-01 01:00:00
Maximum	2020-07-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

PM2.5
Real number (ℝ)

High correlation Missing

Distinct	42154
Distinct (%)	2.5%
Missing	586093
Missing (%)	25.8%
Infinite	0
Infinite (%)	0.0%
Mean	81.158274

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	10
Q1	28.5
median	52.75
Q3	97
95-th percentile	253.7
Maximum	1000
Range	999.99
Interquartile range (IQR)	68.5

Descriptive statistics

Standard deviation	90.269788
Coefficient of variation (CV)	1.1122685
Kurtosis	18.283875
Mean	81.158274
Median Absolute Deviation (MAD)	29.25
Skewness	3.3631464
Sum	1.3668327 × 10⁸
Variance	8148.6347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	4844	0.2%
27	4813	0.2%
56	4684	0.2%
33	4590	0.2%
28	4577	0.2%
29	4546	0.2%
39	4543	0.2%
40	4500	0.2%
38	4455	0.2%
25	4432	0.2%
Other values (42144)	1638173	72.2%
(Missing)	586093	25.8%

Value	Count	Frequency (%)
0.01	31	< 0.1%
0.02	46	< 0.1%
0.03	62	< 0.1%
0.04	49	< 0.1%
0.05	42	< 0.1%
0.06	32	< 0.1%
0.07	38	< 0.1%
0.08	42	< 0.1%
0.09	36	< 0.1%
0.1	59	< 0.1%

Value	Count	Frequency (%)
1000	182	< 0.1%
999.99	359	< 0.1%
999.75	2	< 0.1%
999.5	2	< 0.1%
999.25	1	< 0.1%
998.75	1	< 0.1%
998	1	< 0.1%
997.51	1	< 0.1%
997.5	1	< 0.1%
997.45	1	< 0.1%

PM10
Real number (ℝ)

High correlation Missing

Distinct	56323
Distinct (%)	4.0%
Missing	877210
Missing (%)	38.6%
Infinite	0
Infinite (%)	0.0%
Mean	161.5534

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	26.05
Q1	66.5
median	118.75
Q3	207.8325
95-th percentile	447
Maximum	1000
Range	999.99
Interquartile range (IQR)	141.3325

Descriptive statistics

Standard deviation	141.1247
Coefficient of variation (CV)	0.87354832
Kurtosis	5.4217206
Mean	161.5534
Median Absolute Deviation (MAD)	62.5
Skewness	2.0290261
Sum	2.2505034 × 10⁸
Variance	19916.18
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	4812	0.2%
56	1860	0.1%
69	1821	0.1%
59	1814	0.1%
53	1809	0.1%
80	1799	0.1%
64	1772	0.1%
86	1767	0.1%
50	1758	0.1%
72	1751	0.1%
Other values (56313)	1372077	60.4%
(Missing)	877210	38.6%

Value	Count	Frequency (%)
0.01	24	< 0.1%
0.02	30	< 0.1%
0.03	45	< 0.1%
0.04	35	< 0.1%
0.05	36	< 0.1%
0.06	49	< 0.1%
0.07	32	< 0.1%
0.08	44	< 0.1%
0.09	37	< 0.1%
0.1	46	< 0.1%

Value	Count	Frequency (%)
1000	189	< 0.1%
999.99	234	< 0.1%
999.96	1	< 0.1%
999.83	1	< 0.1%
999.75	3	< 0.1%
999.33	1	< 0.1%
999.16	1	< 0.1%
999	2	< 0.1%
998.9	1	< 0.1%
998.58	1	< 0.1%

NO
Real number (ℝ)

High correlation Missing

Distinct	35996
Distinct (%)	2.0%
Missing	498538
Missing (%)	22.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.6537

Minimum	0.01
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	0.84
Q1	2.97
median	7.15
Q3	20.3
95-th percentile	106.92
Maximum	500
Range	499.99
Interquartile range (IQR)	17.33

Descriptive statistics

Standard deviation	49.339692
Coefficient of variation (CV)	2.0859186
Kurtosis	26.828511
Mean	23.6537
Median Absolute Deviation (MAD)	5.25
Skewness	4.6254692
Sum	41907544
Variance	2434.4052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.8	3803	0.2%
1.5	3741	0.2%
1	3712	0.2%
0.9	3685	0.2%
1.1	3587	0.2%
1.4	3526	0.2%
0.7	3502	0.2%
1.3	3451	0.2%
0.6	3450	0.2%
1.6	3450	0.2%
Other values (35986)	1735805	76.5%
(Missing)	498538	22.0%

Value	Count	Frequency (%)
0.01	166	< 0.1%
0.02	229	< 0.1%
0.03	239	< 0.1%
0.04	185	< 0.1%
0.05	216	< 0.1%
0.06	183	< 0.1%
0.07	215	< 0.1%
0.08	243	< 0.1%
0.09	152	< 0.1%
0.1	1369	0.1%

Value	Count	Frequency (%)
500	1	< 0.1%
499.99	2	< 0.1%
499.9	1	< 0.1%
499.8	3	< 0.1%
499.76	1	< 0.1%
499.74	1	< 0.1%
499.7	2	< 0.1%
499.67	1	< 0.1%
499.65	1	< 0.1%
499.63	1	< 0.1%

NO2
Real number (ℝ)

High correlation Missing

Distinct	25948
Distinct (%)	1.4%
Missing	475550
Missing (%)	20.9%
Infinite	0
Infinite (%)	0.0%
Mean	35.856924

Minimum	0.01
Maximum	499.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	4.29
Q1	13.38
median	25.35
Q3	46.5
95-th percentile	101.4
Maximum	499.99
Range	499.98
Interquartile range (IQR)	33.12

Descriptive statistics

Standard deviation	35.296569
Coefficient of variation (CV)	0.98437248
Kurtosis	16.94144
Mean	35.856924
Median Absolute Deviation (MAD)	14.37
Skewness	3.0135721
Sum	64352422
Variance	1245.8478
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	1131	< 0.1%
9	1059	< 0.1%
15	993	< 0.1%
24	928	< 0.1%
14	924	< 0.1%
10	914	< 0.1%
14.5	908	< 0.1%
12	891	< 0.1%
11	882	< 0.1%
15.5	875	< 0.1%
Other values (25938)	1785195	78.6%
(Missing)	475550	20.9%

Value	Count	Frequency (%)
0.01	163	< 0.1%
0.02	300	< 0.1%
0.03	342	< 0.1%
0.04	298	< 0.1%
0.05	246	< 0.1%
0.06	249	< 0.1%
0.07	269	< 0.1%
0.08	232	< 0.1%
0.09	190	< 0.1%
0.1	664	< 0.1%

Value	Count	Frequency (%)
499.99	2	< 0.1%
499.97	1	< 0.1%
499.8	1	< 0.1%
499.51	1	< 0.1%
499.28	1	< 0.1%
498.96	1	< 0.1%
498.4	1	< 0.1%
498.3	1	< 0.1%
497.94	1	< 0.1%
497.81	1	< 0.1%

NOx
Real number (ℝ)

High correlation Missing Zeros

Distinct	39904
Distinct (%)	2.2%
Missing	429916
Missing (%)	18.9%
Infinite	0
Infinite (%)	0.0%
Mean	41.496408

Minimum	0
Maximum	500
Zeros	116602
Zeros (%)	5.1%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11.46
median	23.45
Q3	47.12
95-th percentile	146.51
Maximum	500
Range	500
Interquartile range (IQR)	35.66

Descriptive statistics

Standard deviation	56.632448
Coefficient of variation (CV)	1.3647554
Kurtosis	16.203575
Mean	41.496408
Median Absolute Deviation (MAD)	14.88
Skewness	3.5120335
Sum	76367251
Variance	3207.2342
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	116602	5.1%
5	1307	0.1%
4.9	1187	0.1%
10	1047	< 0.1%
9	1021	< 0.1%
7	1010	< 0.1%
11.5	971	< 0.1%
11	948	< 0.1%
12	896	< 0.1%
9.5	889	< 0.1%
Other values (39894)	1714456	75.5%
(Missing)	429916	18.9%

Value	Count	Frequency (%)
0	116602	5.1%
0.01	79	< 0.1%
0.02	79	< 0.1%
0.03	245	< 0.1%
0.04	81	< 0.1%
0.05	184	< 0.1%
0.06	40	< 0.1%
0.07	65	< 0.1%
0.08	121	< 0.1%
0.09	52	< 0.1%

Value	Count	Frequency (%)
500	4	< 0.1%
499.99	2	< 0.1%
499.97	1	< 0.1%
499.95	1	< 0.1%
499.94	1	< 0.1%
499.9	2	< 0.1%
499.87	1	< 0.1%
499.82	1	< 0.1%
499.8	2	< 0.1%
499.73	1	< 0.1%

NH3
Real number (ℝ)

Missing

Distinct	18388
Distinct (%)	1.5%
Missing	1041931
Missing (%)	45.9%
Infinite	0
Infinite (%)	0.0%
Mean	28.486834

Minimum	0.01
Maximum	499.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	3.62
Q1	11.46
median	22.53
Q3	37.9
95-th percentile	72.42
Maximum	499.97
Range	499.96
Interquartile range (IQR)	26.44

Descriptive statistics

Standard deviation	25.860621
Coefficient of variation (CV)	0.90780959
Kurtosis	30.47983
Mean	28.486834
Median Absolute Deviation (MAD)	12.35
Skewness	3.6194471
Sum	34990919
Variance	668.77172
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	1403	0.1%
9	1193	0.1%
14.62	954	< 0.1%
7	881	< 0.1%
5	868	< 0.1%
26	844	< 0.1%
0.1	824	< 0.1%
13	801	< 0.1%
10.3	796	< 0.1%
12	793	< 0.1%
Other values (18378)	1218962	53.7%
(Missing)	1041931	45.9%

Value	Count	Frequency (%)
0.01	115	< 0.1%
0.02	101	< 0.1%
0.03	133	< 0.1%
0.04	81	< 0.1%
0.05	146	< 0.1%
0.06	51	< 0.1%
0.07	66	< 0.1%
0.08	139	< 0.1%
0.09	36	< 0.1%
0.1	824	< 0.1%

Value	Count	Frequency (%)
499.97	1	< 0.1%
499.56	1	< 0.1%
499.12	1	< 0.1%
498.54	1	< 0.1%
497.99	1	< 0.1%
494.11	1	< 0.1%
493.6	1	< 0.1%
493.22	1	< 0.1%
492.53	1	< 0.1%
491.95	1	< 0.1%

CO
Real number (ℝ)

Missing Skewed Zeros

Distinct	7192
Distinct (%)	0.4%
Missing	445276
Missing (%)	19.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.5532694

Minimum	0
Maximum	498.57
Zeros	153506
Zeros (%)	6.8%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.42
median	0.8
Q3	1.4
95-th percentile	3.74
Maximum	498.57
Range	498.57
Interquartile range (IQR)	0.98

Descriptive statistics

Standard deviation	6.6755007
Coefficient of variation (CV)	4.2977095
Kurtosis	1474.0114
Mean	1.5532694
Median Absolute Deviation (MAD)	0.45
Skewness	32.056399
Sum	2834676.3
Variance	44.56231
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	153506	6.8%
0.7	20313	0.9%
0.8	19566	0.9%
0.6	19442	0.9%
0.5	19336	0.9%
0.4	19233	0.8%
0.3	15795	0.7%
0.55	14926	0.7%
0.53	14645	0.6%
0.72	14639	0.6%
Other values (7182)	1513573	66.7%
(Missing)	445276	19.6%

Value	Count	Frequency (%)
0	153506	6.8%
0.01	3252	0.1%
0.02	2684	0.1%
0.03	2081	0.1%
0.04	2062	0.1%
0.05	2350	0.1%
0.06	2158	0.1%
0.07	2381	0.1%
0.08	2907	0.1%
0.09	2334	0.1%

Value	Count	Frequency (%)
498.57	1	< 0.1%
494.9	1	< 0.1%
490.35	1	< 0.1%
485.73	1	< 0.1%
483.37	1	< 0.1%
476.2	1	< 0.1%
476.02	1	< 0.1%
475.4	1	< 0.1%
473.81	1	< 0.1%
470.72	1	< 0.1%

SO2
Real number (ℝ)

Missing

Distinct	15102
Distinct (%)	1.0%
Missing	684419
Missing (%)	30.1%
Infinite	0
Infinite (%)	0.0%
Mean	12.710465

Minimum	0.01
Maximum	199.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	1.41
Q1	4.46
median	8.74
Q3	15.3
95-th percentile	36.62
Maximum	199.96
Range	199.95
Interquartile range (IQR)	10.84

Descriptive statistics

Standard deviation	15.125598
Coefficient of variation (CV)	1.1900114
Kurtosis	33.144321
Mean	12.710465
Median Absolute Deviation (MAD)	4.96
Skewness	4.5884278
Sum	20156650
Variance	228.78373
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	2987	0.1%
2.5	2662	0.1%
2	2635	0.1%
4	2525	0.1%
3.5	2403	0.1%
5.5	2340	0.1%
5	2318	0.1%
2.9	2214	0.1%
0.1	2199	0.1%
1.5	2182	0.1%
Other values (15092)	1561366	68.8%
(Missing)	684419	30.1%

Value	Count	Frequency (%)
0.01	278	< 0.1%
0.02	350	< 0.1%
0.03	395	< 0.1%
0.04	374	< 0.1%
0.05	305	< 0.1%
0.06	294	< 0.1%
0.07	270	< 0.1%
0.08	294	< 0.1%
0.09	245	< 0.1%
0.1	2199	0.1%

Value	Count	Frequency (%)
199.96	2	< 0.1%
199.93	1	< 0.1%
199.9	1	< 0.1%
199.85	1	< 0.1%
199.81	1	< 0.1%
199.77	1	< 0.1%
199.75	1	< 0.1%
199.72	1	< 0.1%
199.7	1	< 0.1%
199.65	1	< 0.1%

O3
Real number (ℝ)

Missing

Distinct	23096
Distinct (%)	1.4%
Missing	624138
Missing (%)	27.5%
Infinite	0
Infinite (%)	0.0%
Mean	38.661204

Minimum	0.01
Maximum	997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	2.92
Q1	10.89
median	24.77
Q3	50.23
95-th percentile	113.87
Maximum	997
Range	996.99
Interquartile range (IQR)	39.34

Descriptive statistics

Standard deviation	48.856479
Coefficient of variation (CV)	1.2637082
Kurtosis	55.828533
Mean	38.661204
Median Absolute Deviation (MAD)	16.7
Skewness	5.4764468
Sum	63640671
Variance	2386.9555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	1415	0.1%
2	1266	0.1%
3	1252	0.1%
4	1150	0.1%
1	1130	< 0.1%
3.5	1079	< 0.1%
1.5	1056	< 0.1%
5.5	1050	< 0.1%
7	1047	< 0.1%
4.5	1037	< 0.1%
Other values (23086)	1634630	72.0%
(Missing)	624138	27.5%

Value	Count	Frequency (%)
0.01	182	< 0.1%
0.02	193	< 0.1%
0.03	163	< 0.1%
0.04	123	< 0.1%
0.05	103	< 0.1%
0.06	118	< 0.1%
0.07	123	< 0.1%
0.08	110	< 0.1%
0.09	94	< 0.1%
0.1	621	< 0.1%

Value	Count	Frequency (%)
997	1	< 0.1%
996	2	< 0.1%
992	1	< 0.1%
989	1	< 0.1%
988.17	1	< 0.1%
984.33	1	< 0.1%
982	2	< 0.1%
980	1	< 0.1%
977	1	< 0.1%
975	1	< 0.1%

Benzene
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	7409
Distinct (%)	0.5%
Missing	751495
Missing (%)	33.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.9410816

Minimum	0
Maximum	498.07
Zeros	333688
Zeros (%)	14.7%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1
median	0.96
Q3	3.22
95-th percentile	10.97
Maximum	498.07
Range	498.07
Interquartile range (IQR)	3.12

Descriptive statistics

Standard deviation	10.915072
Coefficient of variation (CV)	3.711244
Kurtosis	1105.2071
Mean	2.9410816
Median Absolute Deviation (MAD)	0.96
Skewness	29.288111
Sum	4466782.4
Variance	119.13879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	333688	14.7%
0.1	43367	1.9%
0.2	22192	1.0%
0.3	15510	0.7%
0.4	12959	0.6%
0.35	9018	0.4%
0.45	8261	0.4%
0.15	8210	0.4%
0.23	7794	0.3%
0.6	7698	0.3%
Other values (7399)	1050058	46.3%
(Missing)	751495	33.1%

Value	Count	Frequency (%)
0	333688	14.7%
0.01	4030	0.2%
0.02	2980	0.1%
0.03	6207	0.3%
0.04	3787	0.2%
0.05	5918	0.3%
0.06	2495	0.1%
0.07	2961	0.1%
0.08	5317	0.2%
0.09	2366	0.1%

Value	Count	Frequency (%)
498.07	4	< 0.1%
491.51	8	< 0.1%
490	1	< 0.1%
488.48	1	< 0.1%
487.79	1	< 0.1%
487.6	1	< 0.1%
487.21	1	< 0.1%
487.2	1	< 0.1%
486.58	1	< 0.1%
485.69	1	< 0.1%

Toluene
Real number (ℝ)

High correlation Missing Zeros

Distinct	23291
Distinct (%)	1.7%
Missing	929412
Missing (%)	40.9%
Infinite	0
Infinite (%)	0.0%
Mean	15.851404

Minimum	0
Maximum	499.8
Zeros	262296
Zeros (%)	11.6%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.46
median	3.67
Q3	16.78
95-th percentile	67.98
Maximum	499.8
Range	499.8
Interquartile range (IQR)	16.32

Descriptive statistics

Standard deviation	34.508012
Coefficient of variation (CV)	2.1769688
Kurtosis	47.468857
Mean	15.851404
Median Absolute Deviation (MAD)	3.67
Skewness	5.6872433
Sum	21254165
Variance	1190.8029
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	262296	11.6%
0.1	6290	0.3%
0.2	5803	0.3%
1.1	4880	0.2%
0.3	4865	0.2%
0.5	4650	0.2%
0.6	4032	0.2%
0.8	3633	0.2%
0.9	3528	0.2%
0.4	3351	0.1%
Other values (23281)	1037510	45.7%
(Missing)	929412	40.9%

Value	Count	Frequency (%)
0	262296	11.6%
0.01	905	< 0.1%
0.02	1184	0.1%
0.03	1847	0.1%
0.04	1001	< 0.1%
0.05	1665	0.1%
0.06	810	< 0.1%
0.07	908	< 0.1%
0.08	1635	0.1%
0.09	839	< 0.1%

Value	Count	Frequency (%)
499.8	1	< 0.1%
499.5	2	< 0.1%
499.4	1	< 0.1%
499.2	1	< 0.1%
499.08	1	< 0.1%
499.05	1	< 0.1%
498.9	1	< 0.1%
498.8	1	< 0.1%
498.6	1	< 0.1%
498.2	1	< 0.1%

Xylene
Real number (ℝ)

High correlation Missing Zeros

Distinct	5812
Distinct (%)	1.2%
Missing	1781769
Missing (%)	78.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.4422641

Minimum	0
Maximum	499.99
Zeros	207980
Zeros (%)	9.2%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.15
Q3	1.65
95-th percentile	11.02
Maximum	499.99
Range	499.99
Interquartile range (IQR)	1.65

Descriptive statistics

Standard deviation	9.1703914
Coefficient of variation (CV)	3.7548729
Kurtosis	428.41132
Mean	2.4422641
Median Absolute Deviation (MAD)	0.15
Skewness	16.100857
Sum	1192999.6
Variance	84.096079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	207980	9.2%
0.1	11393	0.5%
2	6134	0.3%
0.65	5562	0.2%
0.2	3928	0.2%
0.03	3694	0.2%
0.3	3685	0.2%
0.05	3571	0.2%
0.4	3362	0.1%
0.08	2910	0.1%
Other values (5802)	236262	10.4%
(Missing)	1781769	78.5%

Value	Count	Frequency (%)
0	207980	9.2%
0.01	1917	0.1%
0.02	1525	0.1%
0.03	3694	0.2%
0.04	1756	0.1%
0.05	3571	0.2%
0.06	1121	< 0.1%
0.07	1476	0.1%
0.08	2910	0.1%
0.09	973	< 0.1%

Value	Count	Frequency (%)
499.99	1	< 0.1%
476.31	1	< 0.1%
461.39	1	< 0.1%
433.94	1	< 0.1%
423.48	1	< 0.1%
422.86	1	< 0.1%
419.88	1	< 0.1%
406.29	1	< 0.1%
402.64	1	< 0.1%
398.9	1	< 0.1%

AQI
Real number (ℝ)

High correlation Missing

Distinct	1601
Distinct (%)	0.1%
Missing	509518
Missing (%)	22.4%
Infinite	0
Infinite (%)	0.0%
Mean	182.43495

Minimum	5
Maximum	3133
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.3 MiB

Quantile statistics

Minimum	5
5-th percentile	45
Q1	87
median	133
Q3	260
95-th percentile	422
Maximum	3133
Range	3128
Interquartile range (IQR)	173

Descriptive statistics

Standard deviation	143.06418
Coefficient of variation (CV)	0.78419282
Kurtosis	40.535023
Mean	182.43495
Median Absolute Deviation (MAD)	63
Skewness	3.6413137
Sum	3.2121905 × 10⁸
Variance	20467.359
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102	14853	0.7%
101	13973	0.6%
104	13829	0.6%
100	12820	0.6%
106	12629	0.6%
103	12561	0.6%
105	11958	0.5%
108	11437	0.5%
110	11211	0.5%
109	11073	0.5%
Other values (1591)	1634388	72.0%
(Missing)	509518	22.4%

Value	Count	Frequency (%)
5	4	< 0.1%
6	34	< 0.1%
7	64	< 0.1%
8	27	< 0.1%
9	62	< 0.1%
10	112	< 0.1%
11	102	< 0.1%
12	126	< 0.1%
13	127	< 0.1%
14	152	< 0.1%

Value	Count	Frequency (%)
3133	8	< 0.1%
3111	8	< 0.1%
3084	8	< 0.1%
3057	8	< 0.1%
3043	8	< 0.1%
3001	8	< 0.1%
3000	8	< 0.1%
2996	8	< 0.1%
2987	8	< 0.1%
2969	8	< 0.1%

AQI_Bucket
Categorical

Missing

Distinct	6
Distinct (%)	< 0.1%
Missing	509518
Missing (%)	22.4%
Memory size	136.8 MiB

Moderate	612335
Satisfactory	444915
Very Poor	257380
Poor	211506
Good	124482

Length

Max length	12
Median length	9
Mean length	8.2685588
Min length	4

Characters and Unicode

Total characters	14558716
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Moderate	612335	27.0%
Satisfactory	444915	19.6%
Very Poor	257380	11.3%
Poor	211506	9.3%
Good	124482	5.5%
Severe	110114	4.9%
(Missing)	509518	22.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
moderate	612335	30.3%
poor	468886	23.2%
satisfactory	444915	22.0%
very	257380	12.8%
good	124482	6.2%
severe	110114	5.5%

Most occurring characters

Value	Count	Frequency (%)
o	2243986	15.4%
r	1893630	13.0%
e	1812392	12.4%
a	1502165	10.3%
t	1502165	10.3%
d	736817	5.1%
y	702295	4.8%
M	612335	4.2%
S	555029	3.8%
P	468886	3.2%
Other values (8)	2529016	17.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14558716	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	2243986	15.4%
r	1893630	13.0%
e	1812392	12.4%
a	1502165	10.3%
t	1502165	10.3%
d	736817	5.1%
y	702295	4.8%
M	612335	4.2%
S	555029	3.8%
P	468886	3.2%
Other values (8)	2529016	17.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14558716	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	2243986	15.4%
r	1893630	13.0%
e	1812392	12.4%
a	1502165	10.3%
t	1502165	10.3%
d	736817	5.1%
y	702295	4.8%
M	612335	4.2%
S	555029	3.8%
P	468886	3.2%
Other values (8)	2529016	17.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14558716	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	2243986	15.4%
r	1893630	13.0%
e	1812392	12.4%
a	1502165	10.3%
t	1502165	10.3%
d	736817	5.1%
y	702295	4.8%
M	612335	4.2%
S	555029	3.8%
P	468886	3.2%
Other values (8)	2529016	17.4%

	AQI	AQI_Bucket	Benzene	CO	NH3	NO	NO2	NOx	O3	PM10	PM2.5	SO2	Toluene	Xylene
AQI	1.000	0.414	0.366	0.443	0.500	0.357	0.446	0.440	0.068	0.798	0.772	0.352	0.353	0.132
AQI_Bucket	0.414	1.000	0.021	0.073	0.169	0.146	0.172	0.176	0.129	0.422	0.371	0.122	0.114	0.021
Benzene	0.366	0.021	1.000	0.370	0.310	0.284	0.442	0.393	-0.068	0.379	0.380	0.251	0.827	0.785
CO	0.443	0.073	0.370	1.000	0.364	0.423	0.396	0.491	-0.149	0.451	0.429	0.271	0.415	0.341
NH3	0.500	0.169	0.310	0.364	1.000	0.260	0.438	0.371	-0.003	0.466	0.478	0.250	0.368	0.019
NO	0.357	0.146	0.284	0.423	0.260	1.000	0.472	0.763	-0.342	0.385	0.396	0.207	0.246	0.174
NO2	0.446	0.172	0.442	0.396	0.438	0.472	1.000	0.774	-0.072	0.482	0.468	0.267	0.457	0.245
NOx	0.440	0.176	0.393	0.491	0.371	0.763	0.774	1.000	-0.224	0.469	0.453	0.236	0.366	0.259
O3	0.068	0.129	-0.068	-0.149	-0.003	-0.342	-0.072	-0.224	1.000	-0.048	-0.049	0.063	-0.084	-0.013
PM10	0.798	0.422	0.379	0.451	0.466	0.385	0.482	0.469	-0.048	1.000	0.870	0.332	0.344	0.065
PM2.5	0.772	0.371	0.380	0.429	0.478	0.396	0.468	0.453	-0.049	0.870	1.000	0.304	0.335	0.150
SO2	0.352	0.122	0.251	0.271	0.250	0.207	0.267	0.236	0.063	0.332	0.304	1.000	0.360	0.258
Toluene	0.353	0.114	0.827	0.415	0.368	0.246	0.457	0.366	-0.084	0.344	0.335	0.360	1.000	0.724
Xylene	0.132	0.021	0.785	0.341	0.019	0.174	0.245	0.259	-0.013	0.065	0.150	0.258	0.724	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	StationId	Datetime	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
0	AP001	2017-11-24 17:00:00	60.50	98.00	2.35	30.80	18.25	8.50	0.1	11.85	126.40	0.10	6.10	0.10	NaN	NaN
1	AP001	2017-11-24 18:00:00	65.50	111.25	2.70	24.20	15.07	9.77	0.1	13.17	117.12	0.10	6.25	0.15	NaN	NaN
2	AP001	2017-11-24 19:00:00	80.00	132.00	2.10	25.18	15.15	12.02	0.1	12.08	98.98	0.20	5.98	0.18	NaN	NaN
3	AP001	2017-11-24 20:00:00	81.50	133.25	1.95	16.25	10.23	11.58	0.1	10.47	112.20	0.20	6.72	0.10	NaN	NaN
4	AP001	2017-11-24 21:00:00	75.25	116.00	1.43	17.48	10.43	12.03	0.1	9.12	106.35	0.20	5.75	0.08	NaN	NaN
5	AP001	2017-11-24 22:00:00	69.25	108.25	0.70	18.47	10.38	13.80	0.1	9.25	91.10	0.20	5.02	0.00	NaN	NaN
6	AP001	2017-11-24 23:00:00	67.50	111.50	1.05	12.15	7.30	17.65	0.1	9.40	112.70	0.20	5.60	0.10	NaN	NaN
7	AP001	2017-11-25 00:00:00	68.00	111.00	1.25	14.12	8.50	20.28	0.1	8.90	116.12	0.20	5.55	0.05	NaN	NaN
8	AP001	2017-11-25 01:00:00	73.00	102.00	0.30	14.30	7.90	11.50	0.3	11.80	121.50	0.20	6.60	0.00	NaN	NaN
9	AP001	2017-11-25 02:00:00	81.00	123.00	0.80	24.85	13.88	10.28	0.1	11.62	83.80	0.23	6.77	0.10	NaN	NaN

	StationId	Datetime	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
2270240	TN003	2015-12-29 10:00:00	28.33	NaN	4.62	5.96	8.62	165.34	2.31	3.42	NaN	NaN	NaN	NaN	311.0	Very Poor
2270241	TN003	2015-12-29 11:00:00	500.62	NaN	5.19	9.94	11.03	70.24	2.94	3.11	NaN	NaN	NaN	NaN	311.0	Very Poor
2270242	TN003	2015-12-29 12:00:00	81.02	NaN	5.22	10.46	11.29	153.44	0.68	3.28	NaN	NaN	NaN	NaN	311.0	Very Poor
2270243	TN003	2015-12-29 13:00:00	32.47	NaN	5.52	10.14	11.38	142.18	0.12	2.81	NaN	NaN	NaN	NaN	121.0	Moderate
2270244	TN003	2015-12-29 14:00:00	38.03	NaN	4.76	7.53	9.50	74.52	0.44	3.40	NaN	NaN	NaN	NaN	118.0	Moderate
2270245	TN003	2015-12-29 15:00:00	39.05	NaN	4.89	7.59	9.63	83.67	17.10	2.79	NaN	NaN	NaN	NaN	301.0	Very Poor
2270246	TN003	2015-12-29 16:00:00	39.98	NaN	5.01	7.50	9.59	57.02	10.22	6.40	NaN	NaN	NaN	NaN	301.0	Very Poor
2270247	TN003	2015-12-29 17:00:00	49.09	NaN	5.30	9.64	10.96	117.80	NaN	3.23	NaN	NaN	NaN	NaN	301.0	Very Poor
2270248	TN003	2015-12-29 18:00:00	43.32	NaN	5.44	8.70	10.61	266.67	NaN	3.20	NaN	NaN	NaN	NaN	301.0	Very Poor
2270249	TN003	2015-12-29 19:00:00	40.92	NaN	5.10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample